home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CD School House 9
/
CD School House 9.0 - Wayzata Technology (1994).iso
/
pc
/
dos
/
math
/
lp100210
/
budgetss.lp
< prev
next >
Wrap
Text File
|
1989-01-11
|
7KB
|
256 lines
* - This is an example linear program supplied as a demonstration
* for LP100. It generates a solution that will allow optimal
* budgets such as sales, production, inventory, purchases & cash
* to be easily drawn as well as a projected balance sheet and an
* income statement to be created, all optimally the first time.
* -- The preliminary accounting & requirement data are not supplied
* here nor are the finalized budgets.
* --- This file was entered using a 1-2-3 spreadsheet. Though it was
* not developed with spreadsheet data, rather entered manually,
* it could have easily used data from individual worksheet cells
* or consolidation cells (VP-Planner, 1-2-3 v3.0) that would
* automatically reflect any changes in data or requirements
* into a fully-functional matrix generating model.
TITLE: Multi-period Multi-plant Model
LISTING: NO
MAP: NO
TABLEAU: NO
ANALYSIS:YES
VAR: 44
LTE: 14
GTE: 16
EQU: 6
FUNCTION:MAX:
1.58 Xap1 2.2 Xbp1
0 Yap1 0 Ybp1
0 Zwp1 0 Zup1
-.58 Taps1 -.02 Tasp1
-.68 Tbps1 -.12 Tbsp1
1.6 Xas1 2.02 Xbs1
0 Yas1 0 Ybs1
0 Zws1 0 Zus1
-.11 Iap1 -.13 Ibp1
-.11 Ias1 -.13 Ibs1
1.58 Xap2 2.2 Xbp2
0 Yap2 0 Ybp2
0 Zwp2 0 Zup2
-.58 Taps2 -.02 Tasp2
-.68 Tbps2 -.12 Tbsp2
1.6 Xas2 2.02 Xbs2
0 Yas2 0 Ybs2
0 Zws2 0 Zus2
0 V1 -1 Re1 .03 M1 0 Noe1
0 V2 -1 Re2 .03 M2 0 Noe2
pSALa1 1 Xap1
<= 220000
pSALb1 1 Xbp1
<= 300000
pINVa1 -1 Xap1 1 Yap1
1 Taps1 -1 Tasp1
-1 Iap1
>= -5000
pINVb1 -1 Xbp1 1 Ybp1
1 Tbps1 -1 Tbsp1
-1 Ibp1
>= 10000
pPCAP1 .5 Yap1 .6 Ybp1
<= 300000
pRAWw1 -3 Yap1 1 Zwp1
>= 10000
pRAWu1 -2 Ybp1 1 Zup1
>= -10000
sSALa1 1 Xas1
<= 180000
sSALb1 1 Xbs1
<= 150000
sINVa1 -1 Taps1 1 Tasp1
-1 Xas1 1 Yas1
-1 Ias1
>= -2000
sINVb1 -1 Tbps1 1 Tbsp1
-1 Xbs1 1 Ybs1
-1 Ibs1
>= -1500
sPCAP1 .6 Yas1 .7 Ybs1
<= 220000
sRAWw1 -3 Yas1 1 Zws1
>= -2000
sRAWu1 -2 Ybs1 1 Zus1
>= -3000
pSALa2 1 Xap2
<= 250000
pSALb2 1 Xbp2
<= 300000
pINVa2 -1 Xap2 1 Yap2
1 Taps2 -1 Tasp2
1 Iap1
>= 0
pINVb2 -1 Xbp2 1 Ybp2
1 Tbps2 -1 Tbsp2
1 Ibp1
>= 0
pPCAP2 .5 Yap2 .6 Ybp2
<= 280000
pRAWw2 -3 Yap2 1 Zwp2
>= 0
pRAWu2 -2 Ybp2 1 Zup2
>= 0
sSALa2 1 Xas2
<= 150000
sSALb2 1 Xbs2
<= 200000
sINVa2 1 Ias1
-1 Taps2 1 Tasp2
-1 Xas2 1 Yas2
>= 0
sINVb2 1 Ibs1
-1 Tbps2 1 Tbsp2
-1 Xbs2 1 Ybs2
>= 0
sPCAP2 .6 Yas2 .7 Ybs2
<= 230000
sRAWw2 -3 Yas2 1 Zws2
>= 0
sRAWu2 -2 Ybs2 1 Zus2
>= 0
CASH1 3.15 Xap1 4.28 Xbp1
-1.4 Yap1 -1.68 Ybp1
-.14 Zwp1 -.22 Zup1
-.3 Taps1 -.3 Tasp1
-.4 Tbps1 -.4 Tbsp1
3.42 Xas1 4.37 Xbs1
-1.68 Yas1 -1.96 Ybs1
-.14 Zws1 -.22 Zus1
1 V1 -1 M1
= 1451000
DEBTL1 1 V1
<= 50000
INTRS1 -.05 V1 1 Re1
= 5000
PROF1 1.58 Xap1 2.2 Xbp1
-.58 Taps1 -.02 Tasp1
-.68 Tbps1 -.12 Tbsp1
1.6 Xas1 2.02 Xbs1
-1 Re1 .03 M1
-2 Noe1
= 1465000
CASH2 .28 Xap1 .13 Xbp1
-.01 Zwp1 -.015 Zup1
.31 Xas1 .14 Xbs1
-.01 Zws1 -.015 Zus1
3.15 Xap2 4.28 Xbp2
-1.4 Yap2 -1.68 Ybp2
-.14 Zwp2 -.22 Zup2
-.3 Taps2 -.3 Tasp2
-.4 Tbps2 -.4 Tbsp2
3.42 Xas2 4.37 Xbs2
-1.68 Yas2 -1.96 Ybs2
-.14 Zws2 -.22 Zus2
-.25 V1 1.03 M1
-1 Noe1 1 V2
-1 M2
= 1229500
DEBTL2 .8 V1 1 V2
<= 100000
INTRS2 -.04 V1 -.05 V2
1 Re2
= 4500
PROF2 1.58 Xap2 2.2 Xbp2
-.58 Taps2 -.02 Tasp2
-.68 Tbps2 -.12 Tbsp2
1.6 Xas2 2.02 Xbs2
-1 Re2 .03 M2
-2 Noe2
= 1465000
END:
>>>>>>>>>>>> DEFINITIONS <<<<<<<<<<<<
Where: product = a,b
plant = p,s (p=parent s=subsidiary)
period = 1,2
material= w,u
<<< Variable >>>
Xijk Sales of product(i) from plant(j) in period(k)
Yijk Production of product(i) from plant(j) in period(k)
Zijk Raw material purchases of material(i) for plant(j) in period(k)
Iijk Inventory of product(i) in plant(j) at end of period(k)
Tijkl Transport of product(i) to plant(j) from plant(k) in period(l)
Vi New loans taken for period(i)
Rei Interest expense for period(i)
Mi Excess cash available for outside investment in period(i)
Noei Net operating earnings (also taxes (50% tax)) in period(i)
<<< Constraint >>>
iSALjk Demand of plant(i)'s product(j) in period(k)
iINVjk Inventory of plant(i)'s product(j) at the end of period(k)
iPCAPj Production capacity of plant(i) during period(k)
iRAWjk Requirement for plant(i)'s raw material(j) during period(k)
CASHi Requirement for cash during period(i)
DEBTLi Limit of new loans for period(i)
INTRSi Requirement for interest repayment for period(i)
PROFi Requirement for profit to cover fixed overhead for period(i)